<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" pageEncoding="UTF-8" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core_rt" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jstl/fmt_rt" %>

<html>
<head>
    <title>登录页</title>
    <%--echart线图、柱状图、饼图等各种图型库 cdn--%>
    <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/echarts/5.4.3/echarts.min.js"></script>
    <%--jquery cdn--%>
    <script type="text/javascript" src="https://cdn.bootcdn.net/ajax/libs/jquery/3.6.1/jquery.js"></script>
</head>
<body>

<button onclick="excelList()">导出学生列表</button>
<button onclick="excelCityNum()">导出学生城市数量</button>
<table>
    <tr>
        <td>id</td>
        <td>姓名</td>
        <td>年龄</td>
        <td>住址</td>
        <td>城市</td>
    </tr>

    <c:forEach items="${list}" var="l">
        <tr>
            <td>${l.id}</td>
            <td>${l.name}</td>
            <td>${l.age}</td>
            <td>${l.address}</td>
            <td>${l.city}</td>
        </tr>
    </c:forEach>
</table>


</body>
<script>
    function excelList() {
        window.location.href = '/excelList.do'
    }
    function excelCityNum() {
        window.location.href = '/excelCityNum.do'
    }
</script>
</html>